﻿<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="SQL2005_390264_betaDataSet2" targetNamespace="http://tempuri.org/SQL2005_390264_betaDataSet2.xsd" xmlns:mstns="http://tempuri.org/SQL2005_390264_betaDataSet2.xsd" xmlns="http://tempuri.org/SQL2005_390264_betaDataSet2.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
  <xs:annotation>
    <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
      <DataSource DefaultConnectionIndex="1" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
        <Connections>
          <Connection AppSettingsObjectName="Settings" AppSettingsPropertyName="ConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="ConnectionString (Settings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.PPIReporting.Properties.Settings.GlobalReference.Default.ConnectionString" Provider="System.Data.SqlClient" />
          <Connection AppSettingsObjectName="Settings" AppSettingsPropertyName="SQL2005_390264_devpoleposiConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="SQL2005_390264_devpoleposiConnectionString (Settings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.PPIReporting.Properties.Settings.GlobalReference.Default.SQL2005_390264_devpoleposiConnectionString" Provider="System.Data.SqlClient" />
        </Connections>
        <Tables>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="up_Report_InformationAssetTableAdapter" GeneratorDataComponentClassName="up_Report_InformationAssetTableAdapter" Name="up_Report_InformationAsset" UserDataComponentName="up_Report_InformationAssetTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="SQL2005_390264_devpoleposiConnectionString (Settings)" DbObjectName="SQL2005_390264_devpoleposi.dbo.up_Report_InformationAsset" DbObjectType="StoredProcedure" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
                    <CommandText>dbo.up_Report_InformationAsset</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@AssetId" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="Utility_Asset_XMissionStructureId" DataSetColumn="Utility_Asset_XMissionStructureId" />
              <Mapping SourceColumn="UtilityFK" DataSetColumn="UtilityFK" />
              <Mapping SourceColumn="Latitude" DataSetColumn="Latitude" />
              <Mapping SourceColumn="Longitude" DataSetColumn="Longitude" />
              <Mapping SourceColumn="Altitude" DataSetColumn="Altitude" />
              <Mapping SourceColumn="SatelliteCount" DataSetColumn="SatelliteCount" />
              <Mapping SourceColumn="SatelliteTime" DataSetColumn="SatelliteTime" />
              <Mapping SourceColumn="SolutionAvailable" DataSetColumn="SolutionAvailable" />
              <Mapping SourceColumn="Handheld" DataSetColumn="Handheld" />
              <Mapping SourceColumn="XMissionStructures_TopTypeFk" DataSetColumn="XMissionStructures_TopTypeFk" />
              <Mapping SourceColumn="Utility_ContactFK" DataSetColumn="Utility_ContactFK" />
              <Mapping SourceColumn="Date" DataSetColumn="Date" />
              <Mapping SourceColumn="Utility_ProjectFK" DataSetColumn="Utility_ProjectFK" />
              <Mapping SourceColumn="HaveImages" DataSetColumn="HaveImages" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="up_Report_InformationAsset_GpsTableAdapter" GeneratorDataComponentClassName="up_Report_InformationAsset_GpsTableAdapter" Name="up_Report_InformationAsset_Gps" UserDataComponentName="up_Report_InformationAsset_GpsTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="SQL2005_390264_devpoleposiConnectionString (Settings)" DbObjectName="SQL2005_390264_devpoleposi.dbo.up_Report_InformationAsset_Gps" DbObjectType="StoredProcedure" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
                    <CommandText>dbo.up_Report_InformationAsset_Gps</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@AssetId" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="Vendor_Visit_XMissionStructureId" DataSetColumn="Vendor_Visit_XMissionStructureId" />
              <Mapping SourceColumn="Vendor_ProjectFK" DataSetColumn="Vendor_ProjectFK" />
              <Mapping SourceColumn="Utility_Asset_XMissionStructureFK" DataSetColumn="Utility_Asset_XMissionStructureFK" />
              <Mapping SourceColumn="Vendor_Visit_TypeFK" DataSetColumn="Vendor_Visit_TypeFK" />
              <Mapping SourceColumn="XMissionStructures_TopTypeFk" DataSetColumn="XMissionStructures_TopTypeFk" />
              <Mapping SourceColumn="TopType_Name" DataSetColumn="TopType_Name" />
              <Mapping SourceColumn="Structure_Latitude" DataSetColumn="Structure_Latitude" />
              <Mapping SourceColumn="Structure_Altitude" DataSetColumn="Structure_Altitude" />
              <Mapping SourceColumn="Structure_Longitude" DataSetColumn="Structure_Longitude" />
              <Mapping SourceColumn="Structure_SatelliteCount" DataSetColumn="Structure_SatelliteCount" />
              <Mapping SourceColumn="Structure_SatelliteTime" DataSetColumn="Structure_SatelliteTime" />
              <Mapping SourceColumn="Structure_SolutionAvailable" DataSetColumn="Structure_SolutionAvailable" />
              <Mapping SourceColumn="Structure_HaveImages" DataSetColumn="Structure_HaveImages" />
              <Mapping SourceColumn="HandheldFk" DataSetColumn="HandheldFk" />
              <Mapping SourceColumn="Vendor_ContactFK" DataSetColumn="Vendor_ContactFK" />
              <Mapping SourceColumn="Date" DataSetColumn="Date" />
              <Mapping SourceColumn="vendor_Name" DataSetColumn="vendor_Name" />
              <Mapping SourceColumn="visit_Name" DataSetColumn="visit_Name" />
              <Mapping SourceColumn="UploadedImages" DataSetColumn="UploadedImages" />
              <Mapping SourceColumn="TotalImages" DataSetColumn="TotalImages" />
              <Mapping SourceColumn="Pole_ID" DataSetColumn="Pole_ID" />
              <Mapping SourceColumn="Pole_Longitude" DataSetColumn="Pole_Longitude" />
              <Mapping SourceColumn="Pole_Latitude" DataSetColumn="Pole_Latitude" />
              <Mapping SourceColumn="Pole_Altitude" DataSetColumn="Pole_Altitude" />
              <Mapping SourceColumn="Pole_SatelliteCount" DataSetColumn="Pole_SatelliteCount" />
              <Mapping SourceColumn="Pole_SatelliteTime" DataSetColumn="Pole_SatelliteTime" />
              <Mapping SourceColumn="Pole_SolutionAvailable" DataSetColumn="Pole_SolutionAvailable" />
              <Mapping SourceColumn="Pole_HaveImages" DataSetColumn="Pole_HaveImages" />
              <Mapping SourceColumn="Pole_Year" DataSetColumn="Pole_Year" />
              <Mapping SourceColumn="Pole_AID" DataSetColumn="Pole_AID" />
              <Mapping SourceColumn="Pole_LVisit" DataSetColumn="Pole_LVisit" />
              <Mapping SourceColumn="Pole_Number" DataSetColumn="Pole_Number" />
              <Mapping SourceColumn="Pole_Length" DataSetColumn="Pole_Length" />
              <Mapping SourceColumn="Pole_LVisitor" DataSetColumn="Pole_LVisitor" />
              <Mapping SourceColumn="Pole_TopID" DataSetColumn="Pole_TopID" />
              <Mapping SourceColumn="Pole_SpeciesID" DataSetColumn="Pole_SpeciesID" />
              <Mapping SourceColumn="Pole_TreatmentID" DataSetColumn="Pole_TreatmentID" />
              <Mapping SourceColumn="Pole_ClassID" DataSetColumn="Pole_ClassID" />
              <Mapping SourceColumn="Classes_Name" DataSetColumn="Classes_Name" />
              <Mapping SourceColumn="Species_Name" DataSetColumn="Species_Name" />
              <Mapping SourceColumn="Top_Name" DataSetColumn="Top_Name" />
              <Mapping SourceColumn="Treatment_Name" DataSetColumn="Treatment_Name" />
              <Mapping SourceColumn="Vendor_Id" DataSetColumn="Vendor_Id" />
              <Mapping SourceColumn="Company_Name" DataSetColumn="Company_Name" />
              <Mapping SourceColumn="vendor_Contact_Id" DataSetColumn="vendor_Contact_Id" />
              <Mapping SourceColumn="Vendor_Contact_Name" DataSetColumn="Vendor_Contact_Name" />
              <Mapping SourceColumn="Company_Name1" DataSetColumn="Company_Name1" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="up_Report_InformationAsset_InspectionsTableAdapter" GeneratorDataComponentClassName="up_Report_InformationAsset_InspectionsTableAdapter" Name="up_Report_InformationAsset_Inspections" UserDataComponentName="up_Report_InformationAsset_InspectionsTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="SQL2005_390264_devpoleposiConnectionString (Settings)" DbObjectName="SQL2005_390264_devpoleposi.dbo.up_Report_InformationAsset_Inspections" DbObjectType="StoredProcedure" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
                    <CommandText>dbo.up_Report_InformationAsset_Inspections</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@AssetId" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="Vendor_InspVisit_XMissionStructure_PoleId" DataSetColumn="Vendor_InspVisit_XMissionStructure_PoleId" />
              <Mapping SourceColumn="Latitude" DataSetColumn="Latitude" />
              <Mapping SourceColumn="Longitude" DataSetColumn="Longitude" />
              <Mapping SourceColumn="Year" DataSetColumn="Year" />
              <Mapping SourceColumn="LVisit" DataSetColumn="LVisit" />
              <Mapping SourceColumn="Number" DataSetColumn="Number" />
              <Mapping SourceColumn="AcquisitionDate" DataSetColumn="AcquisitionDate" />
              <Mapping SourceColumn="TreatmentFk" DataSetColumn="TreatmentFk" />
              <Mapping SourceColumn="ClassFK" DataSetColumn="ClassFK" />
              <Mapping SourceColumn="SpecieFk" DataSetColumn="SpecieFk" />
              <Mapping SourceColumn="TopTypeFk" DataSetColumn="TopTypeFk" />
              <Mapping SourceColumn="Length" DataSetColumn="Length" />
              <Mapping SourceColumn="InspectorFk" DataSetColumn="InspectorFk" />
              <Mapping SourceColumn="CompanyFk" DataSetColumn="CompanyFk" />
              <Mapping SourceColumn="MapFk" DataSetColumn="MapFk" />
              <Mapping SourceColumn="Vendor_InspVisit_XMissionStructureFk" DataSetColumn="Vendor_InspVisit_XMissionStructureFk" />
              <Mapping SourceColumn="Vendor_ProjectFK" DataSetColumn="Vendor_ProjectFK" />
              <Mapping SourceColumn="Vendor_ContactFK" DataSetColumn="Vendor_ContactFK" />
              <Mapping SourceColumn="SectionFk" DataSetColumn="SectionFk" />
              <Mapping SourceColumn="Utility_Asset_XMissionStructures_PoleFk" DataSetColumn="Utility_Asset_XMissionStructures_PoleFk" />
              <Mapping SourceColumn="Treatment_Name" DataSetColumn="Treatment_Name" />
              <Mapping SourceColumn="TopType_Name" DataSetColumn="TopType_Name" />
              <Mapping SourceColumn="Specie_Name" DataSetColumn="Specie_Name" />
              <Mapping SourceColumn="Class_Name" DataSetColumn="Class_Name" />
              <Mapping SourceColumn="Vendor_InspVisit_XmissionStructures_ResultId" DataSetColumn="Vendor_InspVisit_XmissionStructures_ResultId" />
              <Mapping SourceColumn="Vendor_InspVisit_XMissionStructure_PoleFk" DataSetColumn="Vendor_InspVisit_XMissionStructure_PoleFk" />
              <Mapping SourceColumn="Vendor_InspVisit_XmissionStructures_Inspection_TypeFk" DataSetColumn="Vendor_InspVisit_XmissionStructures_Inspection_TypeFk" />
              <Mapping SourceColumn="Vendor_InspVisit_XmissionStructures_ResultTypeFk" DataSetColumn="Vendor_InspVisit_XmissionStructures_ResultTypeFk" />
              <Mapping SourceColumn="LastInspection" DataSetColumn="LastInspection" />
              <Mapping SourceColumn="Comments" DataSetColumn="Comments" />
              <Mapping SourceColumn="bElectrical" DataSetColumn="bElectrical" />
              <Mapping SourceColumn="Type_Name" DataSetColumn="Type_Name" />
              <Mapping SourceColumn="Result_Name" DataSetColumn="Result_Name" />
              <Mapping SourceColumn="Utility_Asset_XMissionStructureFK" DataSetColumn="Utility_Asset_XMissionStructureFK" />
              <Mapping SourceColumn="Vendor_InspVisit_XmissionStructures_NoteFk" DataSetColumn="Vendor_InspVisit_XmissionStructures_NoteFk" />
              <Mapping SourceColumn="Inspector_Name" DataSetColumn="Inspector_Name" />
              <Mapping SourceColumn="Company_Name" DataSetColumn="Company_Name" />
              <Mapping SourceColumn="Map_Name" DataSetColumn="Map_Name" />
              <Mapping SourceColumn="Note_Name" DataSetColumn="Note_Name" />
            </Mappings>
            <Sources />
          </TableAdapter>
        </Tables>
        <Sources />
      </DataSource>
    </xs:appinfo>
  </xs:annotation>
  <xs:element name="SQL2005_390264_betaDataSet2" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:Generator_UserDSName="SQL2005_390264_betaDataSet2" msprop:Generator_DataSetName="SQL2005_390264_betaDataSet2" msprop:EnableTableAdapterManager="True">
    <xs:complexType>
      <xs:choice minOccurs="0" maxOccurs="unbounded">
        <xs:element name="up_Report_InformationAsset" msprop:Generator_UserTableName="up_Report_InformationAsset" msprop:Generator_RowDeletedName="up_Report_InformationAssetRowDeleted" msprop:Generator_TableClassName="up_Report_InformationAssetDataTable" msprop:Generator_RowChangedName="up_Report_InformationAssetRowChanged" msprop:Generator_RowClassName="up_Report_InformationAssetRow" msprop:Generator_RowChangingName="up_Report_InformationAssetRowChanging" msprop:Generator_RowEvArgName="up_Report_InformationAssetRowChangeEvent" msprop:Generator_RowEvHandlerName="up_Report_InformationAssetRowChangeEventHandler" msprop:Generator_TablePropName="up_Report_InformationAsset" msprop:Generator_TableVarName="tableup_Report_InformationAsset" msprop:Generator_RowDeletingName="up_Report_InformationAssetRowDeleting">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="Utility_Asset_XMissionStructureId" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_UserColumnName="Utility_Asset_XMissionStructureId" msprop:Generator_ColumnPropNameInRow="Utility_Asset_XMissionStructureId" msprop:Generator_ColumnVarNameInTable="columnUtility_Asset_XMissionStructureId" msprop:Generator_ColumnPropNameInTable="Utility_Asset_XMissionStructureIdColumn" type="xs:int" />
              <xs:element name="UtilityFK" msprop:Generator_UserColumnName="UtilityFK" msprop:Generator_ColumnPropNameInRow="UtilityFK" msprop:Generator_ColumnVarNameInTable="columnUtilityFK" msprop:Generator_ColumnPropNameInTable="UtilityFKColumn" type="xs:int" minOccurs="0" />
              <xs:element name="Latitude" msprop:Generator_UserColumnName="Latitude" msprop:Generator_ColumnPropNameInRow="Latitude" msprop:Generator_ColumnVarNameInTable="columnLatitude" msprop:Generator_ColumnPropNameInTable="LatitudeColumn" type="xs:double" minOccurs="0" />
              <xs:element name="Longitude" msprop:Generator_UserColumnName="Longitude" msprop:Generator_ColumnPropNameInRow="Longitude" msprop:Generator_ColumnVarNameInTable="columnLongitude" msprop:Generator_ColumnPropNameInTable="LongitudeColumn" type="xs:double" minOccurs="0" />
              <xs:element name="Altitude" msprop:Generator_UserColumnName="Altitude" msprop:Generator_ColumnPropNameInRow="Altitude" msprop:Generator_ColumnVarNameInTable="columnAltitude" msprop:Generator_ColumnPropNameInTable="AltitudeColumn" type="xs:double" minOccurs="0" />
              <xs:element name="SatelliteCount" msprop:Generator_UserColumnName="SatelliteCount" msprop:Generator_ColumnPropNameInRow="SatelliteCount" msprop:Generator_ColumnVarNameInTable="columnSatelliteCount" msprop:Generator_ColumnPropNameInTable="SatelliteCountColumn" type="xs:int" minOccurs="0" />
              <xs:element name="SatelliteTime" msprop:Generator_UserColumnName="SatelliteTime" msprop:Generator_ColumnPropNameInRow="SatelliteTime" msprop:Generator_ColumnVarNameInTable="columnSatelliteTime" msprop:Generator_ColumnPropNameInTable="SatelliteTimeColumn" type="xs:dateTime" minOccurs="0" />
              <xs:element name="SolutionAvailable" msprop:Generator_UserColumnName="SolutionAvailable" msprop:Generator_ColumnPropNameInRow="SolutionAvailable" msprop:Generator_ColumnVarNameInTable="columnSolutionAvailable" msprop:Generator_ColumnPropNameInTable="SolutionAvailableColumn" type="xs:boolean" />
              <xs:element name="Handheld" msprop:Generator_UserColumnName="Handheld" msprop:Generator_ColumnPropNameInRow="Handheld" msprop:Generator_ColumnVarNameInTable="columnHandheld" msprop:Generator_ColumnPropNameInTable="HandheldColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="XMissionStructures_TopTypeFk" msprop:Generator_UserColumnName="XMissionStructures_TopTypeFk" msprop:Generator_ColumnPropNameInRow="XMissionStructures_TopTypeFk" msprop:Generator_ColumnVarNameInTable="columnXMissionStructures_TopTypeFk" msprop:Generator_ColumnPropNameInTable="XMissionStructures_TopTypeFkColumn" type="xs:int" minOccurs="0" />
              <xs:element name="Utility_ContactFK" msprop:Generator_UserColumnName="Utility_ContactFK" msprop:Generator_ColumnPropNameInRow="Utility_ContactFK" msprop:Generator_ColumnVarNameInTable="columnUtility_ContactFK" msprop:Generator_ColumnPropNameInTable="Utility_ContactFKColumn" type="xs:int" minOccurs="0" />
              <xs:element name="Date" msprop:Generator_UserColumnName="Date" msprop:Generator_ColumnPropNameInRow="Date" msprop:Generator_ColumnVarNameInTable="columnDate" msprop:Generator_ColumnPropNameInTable="DateColumn" type="xs:dateTime" minOccurs="0" />
              <xs:element name="Utility_ProjectFK" msprop:Generator_UserColumnName="Utility_ProjectFK" msprop:Generator_ColumnPropNameInRow="Utility_ProjectFK" msprop:Generator_ColumnVarNameInTable="columnUtility_ProjectFK" msprop:Generator_ColumnPropNameInTable="Utility_ProjectFKColumn" type="xs:int" minOccurs="0" />
              <xs:element name="HaveImages" msprop:Generator_UserColumnName="HaveImages" msprop:Generator_ColumnPropNameInRow="HaveImages" msprop:Generator_ColumnVarNameInTable="columnHaveImages" msprop:Generator_ColumnPropNameInTable="HaveImagesColumn" type="xs:int" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="up_Report_InformationAsset_Gps" msprop:Generator_UserTableName="up_Report_InformationAsset_Gps" msprop:Generator_RowDeletedName="up_Report_InformationAsset_GpsRowDeleted" msprop:Generator_TableClassName="up_Report_InformationAsset_GpsDataTable" msprop:Generator_RowChangedName="up_Report_InformationAsset_GpsRowChanged" msprop:Generator_RowClassName="up_Report_InformationAsset_GpsRow" msprop:Generator_RowChangingName="up_Report_InformationAsset_GpsRowChanging" msprop:Generator_RowEvArgName="up_Report_InformationAsset_GpsRowChangeEvent" msprop:Generator_RowEvHandlerName="up_Report_InformationAsset_GpsRowChangeEventHandler" msprop:Generator_TablePropName="up_Report_InformationAsset_Gps" msprop:Generator_TableVarName="tableup_Report_InformationAsset_Gps" msprop:Generator_RowDeletingName="up_Report_InformationAsset_GpsRowDeleting">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="Vendor_Visit_XMissionStructureId" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_UserColumnName="Vendor_Visit_XMissionStructureId" msprop:Generator_ColumnPropNameInRow="Vendor_Visit_XMissionStructureId" msprop:Generator_ColumnVarNameInTable="columnVendor_Visit_XMissionStructureId" msprop:Generator_ColumnPropNameInTable="Vendor_Visit_XMissionStructureIdColumn" type="xs:int" />
              <xs:element name="Vendor_ProjectFK" msprop:Generator_UserColumnName="Vendor_ProjectFK" msprop:Generator_ColumnPropNameInRow="Vendor_ProjectFK" msprop:Generator_ColumnVarNameInTable="columnVendor_ProjectFK" msprop:Generator_ColumnPropNameInTable="Vendor_ProjectFKColumn" type="xs:int" />
              <xs:element name="Utility_Asset_XMissionStructureFK" msprop:Generator_UserColumnName="Utility_Asset_XMissionStructureFK" msprop:Generator_ColumnPropNameInRow="Utility_Asset_XMissionStructureFK" msprop:Generator_ColumnVarNameInTable="columnUtility_Asset_XMissionStructureFK" msprop:Generator_ColumnPropNameInTable="Utility_Asset_XMissionStructureFKColumn" type="xs:int" minOccurs="0" />
              <xs:element name="Vendor_Visit_TypeFK" msprop:Generator_UserColumnName="Vendor_Visit_TypeFK" msprop:Generator_ColumnPropNameInRow="Vendor_Visit_TypeFK" msprop:Generator_ColumnVarNameInTable="columnVendor_Visit_TypeFK" msprop:Generator_ColumnPropNameInTable="Vendor_Visit_TypeFKColumn" type="xs:int" />
              <xs:element name="XMissionStructures_TopTypeFk" msprop:Generator_UserColumnName="XMissionStructures_TopTypeFk" msprop:Generator_ColumnPropNameInRow="XMissionStructures_TopTypeFk" msprop:Generator_ColumnVarNameInTable="columnXMissionStructures_TopTypeFk" msprop:Generator_ColumnPropNameInTable="XMissionStructures_TopTypeFkColumn" type="xs:int" minOccurs="0" />
              <xs:element name="TopType_Name" msprop:Generator_UserColumnName="TopType_Name" msprop:Generator_ColumnPropNameInRow="TopType_Name" msprop:Generator_ColumnVarNameInTable="columnTopType_Name" msprop:Generator_ColumnPropNameInTable="TopType_NameColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Structure_Latitude" msprop:Generator_UserColumnName="Structure_Latitude" msprop:Generator_ColumnPropNameInRow="Structure_Latitude" msprop:Generator_ColumnVarNameInTable="columnStructure_Latitude" msprop:Generator_ColumnPropNameInTable="Structure_LatitudeColumn" type="xs:double" minOccurs="0" />
              <xs:element name="Structure_Altitude" msprop:Generator_UserColumnName="Structure_Altitude" msprop:Generator_ColumnPropNameInRow="Structure_Altitude" msprop:Generator_ColumnVarNameInTable="columnStructure_Altitude" msprop:Generator_ColumnPropNameInTable="Structure_AltitudeColumn" type="xs:double" minOccurs="0" />
              <xs:element name="Structure_Longitude" msprop:Generator_UserColumnName="Structure_Longitude" msprop:Generator_ColumnPropNameInRow="Structure_Longitude" msprop:Generator_ColumnVarNameInTable="columnStructure_Longitude" msprop:Generator_ColumnPropNameInTable="Structure_LongitudeColumn" type="xs:double" minOccurs="0" />
              <xs:element name="Structure_SatelliteCount" msprop:Generator_UserColumnName="Structure_SatelliteCount" msprop:Generator_ColumnPropNameInRow="Structure_SatelliteCount" msprop:Generator_ColumnVarNameInTable="columnStructure_SatelliteCount" msprop:Generator_ColumnPropNameInTable="Structure_SatelliteCountColumn" type="xs:int" minOccurs="0" />
              <xs:element name="Structure_SatelliteTime" msprop:Generator_UserColumnName="Structure_SatelliteTime" msprop:Generator_ColumnPropNameInRow="Structure_SatelliteTime" msprop:Generator_ColumnVarNameInTable="columnStructure_SatelliteTime" msprop:Generator_ColumnPropNameInTable="Structure_SatelliteTimeColumn" type="xs:dateTime" minOccurs="0" />
              <xs:element name="Structure_SolutionAvailable" msprop:Generator_UserColumnName="Structure_SolutionAvailable" msprop:Generator_ColumnPropNameInRow="Structure_SolutionAvailable" msprop:Generator_ColumnVarNameInTable="columnStructure_SolutionAvailable" msprop:Generator_ColumnPropNameInTable="Structure_SolutionAvailableColumn" type="xs:boolean" />
              <xs:element name="Structure_HaveImages" msprop:Generator_UserColumnName="Structure_HaveImages" msprop:Generator_ColumnPropNameInRow="Structure_HaveImages" msprop:Generator_ColumnVarNameInTable="columnStructure_HaveImages" msprop:Generator_ColumnPropNameInTable="Structure_HaveImagesColumn" type="xs:int" minOccurs="0" />
              <xs:element name="HandheldFk" msprop:Generator_UserColumnName="HandheldFk" msprop:Generator_ColumnPropNameInRow="HandheldFk" msprop:Generator_ColumnVarNameInTable="columnHandheldFk" msprop:Generator_ColumnPropNameInTable="HandheldFkColumn" type="xs:int" minOccurs="0" />
              <xs:element name="Vendor_ContactFK" msprop:Generator_UserColumnName="Vendor_ContactFK" msprop:Generator_ColumnPropNameInRow="Vendor_ContactFK" msprop:Generator_ColumnVarNameInTable="columnVendor_ContactFK" msprop:Generator_ColumnPropNameInTable="Vendor_ContactFKColumn" type="xs:int" minOccurs="0" />
              <xs:element name="Date" msprop:Generator_UserColumnName="Date" msprop:Generator_ColumnPropNameInRow="Date" msprop:Generator_ColumnVarNameInTable="columnDate" msprop:Generator_ColumnPropNameInTable="DateColumn" type="xs:dateTime" minOccurs="0" />
              <xs:element name="vendor_Name" msprop:Generator_UserColumnName="vendor_Name" msprop:Generator_ColumnPropNameInRow="vendor_Name" msprop:Generator_ColumnVarNameInTable="columnvendor_Name" msprop:Generator_ColumnPropNameInTable="vendor_NameColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="visit_Name" msprop:Generator_UserColumnName="visit_Name" msprop:Generator_ColumnPropNameInRow="visit_Name" msprop:Generator_ColumnVarNameInTable="columnvisit_Name" msprop:Generator_ColumnPropNameInTable="visit_NameColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="UploadedImages" msdata:ReadOnly="true" msprop:Generator_UserColumnName="UploadedImages" msprop:Generator_ColumnPropNameInRow="UploadedImages" msprop:Generator_ColumnVarNameInTable="columnUploadedImages" msprop:Generator_ColumnPropNameInTable="UploadedImagesColumn" type="xs:int" minOccurs="0" />
              <xs:element name="TotalImages" msdata:ReadOnly="true" msprop:Generator_UserColumnName="TotalImages" msprop:Generator_ColumnPropNameInRow="TotalImages" msprop:Generator_ColumnVarNameInTable="columnTotalImages" msprop:Generator_ColumnPropNameInTable="TotalImagesColumn" type="xs:int" minOccurs="0" />
              <xs:element name="Pole_ID" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_UserColumnName="Pole_ID" msprop:Generator_ColumnPropNameInRow="Pole_ID" msprop:Generator_ColumnVarNameInTable="columnPole_ID" msprop:Generator_ColumnPropNameInTable="Pole_IDColumn" type="xs:int" minOccurs="0" />
              <xs:element name="Pole_Longitude" msprop:Generator_UserColumnName="Pole_Longitude" msprop:Generator_ColumnPropNameInRow="Pole_Longitude" msprop:Generator_ColumnVarNameInTable="columnPole_Longitude" msprop:Generator_ColumnPropNameInTable="Pole_LongitudeColumn" type="xs:double" minOccurs="0" />
              <xs:element name="Pole_Latitude" msprop:Generator_UserColumnName="Pole_Latitude" msprop:Generator_ColumnPropNameInRow="Pole_Latitude" msprop:Generator_ColumnVarNameInTable="columnPole_Latitude" msprop:Generator_ColumnPropNameInTable="Pole_LatitudeColumn" type="xs:double" minOccurs="0" />
              <xs:element name="Pole_Altitude" msprop:Generator_UserColumnName="Pole_Altitude" msprop:Generator_ColumnPropNameInRow="Pole_Altitude" msprop:Generator_ColumnVarNameInTable="columnPole_Altitude" msprop:Generator_ColumnPropNameInTable="Pole_AltitudeColumn" type="xs:double" minOccurs="0" />
              <xs:element name="Pole_SatelliteCount" msprop:Generator_UserColumnName="Pole_SatelliteCount" msprop:Generator_ColumnPropNameInRow="Pole_SatelliteCount" msprop:Generator_ColumnVarNameInTable="columnPole_SatelliteCount" msprop:Generator_ColumnPropNameInTable="Pole_SatelliteCountColumn" type="xs:int" minOccurs="0" />
              <xs:element name="Pole_SatelliteTime" msprop:Generator_UserColumnName="Pole_SatelliteTime" msprop:Generator_ColumnPropNameInRow="Pole_SatelliteTime" msprop:Generator_ColumnVarNameInTable="columnPole_SatelliteTime" msprop:Generator_ColumnPropNameInTable="Pole_SatelliteTimeColumn" type="xs:dateTime" minOccurs="0" />
              <xs:element name="Pole_SolutionAvailable" msprop:Generator_UserColumnName="Pole_SolutionAvailable" msprop:Generator_ColumnPropNameInRow="Pole_SolutionAvailable" msprop:Generator_ColumnVarNameInTable="columnPole_SolutionAvailable" msprop:Generator_ColumnPropNameInTable="Pole_SolutionAvailableColumn" type="xs:boolean" minOccurs="0" />
              <xs:element name="Pole_HaveImages" msprop:Generator_UserColumnName="Pole_HaveImages" msprop:Generator_ColumnPropNameInRow="Pole_HaveImages" msprop:Generator_ColumnVarNameInTable="columnPole_HaveImages" msprop:Generator_ColumnPropNameInTable="Pole_HaveImagesColumn" type="xs:int" minOccurs="0" />
              <xs:element name="Pole_Year" msprop:Generator_UserColumnName="Pole_Year" msprop:Generator_ColumnPropNameInRow="Pole_Year" msprop:Generator_ColumnVarNameInTable="columnPole_Year" msprop:Generator_ColumnPropNameInTable="Pole_YearColumn" type="xs:int" minOccurs="0" />
              <xs:element name="Pole_AID" msprop:Generator_UserColumnName="Pole_AID" msprop:Generator_ColumnPropNameInRow="Pole_AID" msprop:Generator_ColumnVarNameInTable="columnPole_AID" msprop:Generator_ColumnPropNameInTable="Pole_AIDColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Pole_LVisit" msprop:Generator_UserColumnName="Pole_LVisit" msprop:Generator_ColumnPropNameInRow="Pole_LVisit" msprop:Generator_ColumnVarNameInTable="columnPole_LVisit" msprop:Generator_ColumnPropNameInTable="Pole_LVisitColumn" type="xs:int" minOccurs="0" />
              <xs:element name="Pole_Number" msprop:Generator_UserColumnName="Pole_Number" msprop:Generator_ColumnPropNameInRow="Pole_Number" msprop:Generator_ColumnVarNameInTable="columnPole_Number" msprop:Generator_ColumnPropNameInTable="Pole_NumberColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Pole_Length" msprop:Generator_UserColumnName="Pole_Length" msprop:Generator_ColumnPropNameInRow="Pole_Length" msprop:Generator_ColumnVarNameInTable="columnPole_Length" msprop:Generator_ColumnPropNameInTable="Pole_LengthColumn" type="xs:double" minOccurs="0" />
              <xs:element name="Pole_LVisitor" msprop:Generator_UserColumnName="Pole_LVisitor" msprop:Generator_ColumnPropNameInRow="Pole_LVisitor" msprop:Generator_ColumnVarNameInTable="columnPole_LVisitor" msprop:Generator_ColumnPropNameInTable="Pole_LVisitorColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Pole_TopID" msprop:Generator_UserColumnName="Pole_TopID" msprop:Generator_ColumnPropNameInRow="Pole_TopID" msprop:Generator_ColumnVarNameInTable="columnPole_TopID" msprop:Generator_ColumnPropNameInTable="Pole_TopIDColumn" type="xs:int" minOccurs="0" />
              <xs:element name="Pole_SpeciesID" msprop:Generator_UserColumnName="Pole_SpeciesID" msprop:Generator_ColumnPropNameInRow="Pole_SpeciesID" msprop:Generator_ColumnVarNameInTable="columnPole_SpeciesID" msprop:Generator_ColumnPropNameInTable="Pole_SpeciesIDColumn" type="xs:int" minOccurs="0" />
              <xs:element name="Pole_TreatmentID" msprop:Generator_UserColumnName="Pole_TreatmentID" msprop:Generator_ColumnPropNameInRow="Pole_TreatmentID" msprop:Generator_ColumnVarNameInTable="columnPole_TreatmentID" msprop:Generator_ColumnPropNameInTable="Pole_TreatmentIDColumn" type="xs:int" minOccurs="0" />
              <xs:element name="Pole_ClassID" msprop:Generator_UserColumnName="Pole_ClassID" msprop:Generator_ColumnPropNameInRow="Pole_ClassID" msprop:Generator_ColumnVarNameInTable="columnPole_ClassID" msprop:Generator_ColumnPropNameInTable="Pole_ClassIDColumn" type="xs:int" minOccurs="0" />
              <xs:element name="Classes_Name" msprop:Generator_UserColumnName="Classes_Name" msprop:Generator_ColumnPropNameInRow="Classes_Name" msprop:Generator_ColumnVarNameInTable="columnClasses_Name" msprop:Generator_ColumnPropNameInTable="Classes_NameColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Species_Name" msprop:Generator_UserColumnName="Species_Name" msprop:Generator_ColumnPropNameInRow="Species_Name" msprop:Generator_ColumnVarNameInTable="columnSpecies_Name" msprop:Generator_ColumnPropNameInTable="Species_NameColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Top_Name" msprop:Generator_UserColumnName="Top_Name" msprop:Generator_ColumnPropNameInRow="Top_Name" msprop:Generator_ColumnVarNameInTable="columnTop_Name" msprop:Generator_ColumnPropNameInTable="Top_NameColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Treatment_Name" msprop:Generator_UserColumnName="Treatment_Name" msprop:Generator_ColumnPropNameInRow="Treatment_Name" msprop:Generator_ColumnVarNameInTable="columnTreatment_Name" msprop:Generator_ColumnPropNameInTable="Treatment_NameColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Vendor_Id" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_UserColumnName="Vendor_Id" msprop:Generator_ColumnPropNameInRow="Vendor_Id" msprop:Generator_ColumnVarNameInTable="columnVendor_Id" msprop:Generator_ColumnPropNameInTable="Vendor_IdColumn" type="xs:int" minOccurs="0" />
              <xs:element name="Company_Name" msprop:Generator_UserColumnName="Company_Name" msprop:Generator_ColumnPropNameInRow="Company_Name" msprop:Generator_ColumnVarNameInTable="columnCompany_Name" msprop:Generator_ColumnPropNameInTable="Company_NameColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="vendor_Contact_Id" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_UserColumnName="vendor_Contact_Id" msprop:Generator_ColumnPropNameInRow="vendor_Contact_Id" msprop:Generator_ColumnVarNameInTable="columnvendor_Contact_Id" msprop:Generator_ColumnPropNameInTable="vendor_Contact_IdColumn" type="xs:int" minOccurs="0" />
              <xs:element name="Vendor_Contact_Name" msprop:Generator_UserColumnName="Vendor_Contact_Name" msprop:Generator_ColumnPropNameInRow="Vendor_Contact_Name" msprop:Generator_ColumnVarNameInTable="columnVendor_Contact_Name" msprop:Generator_ColumnPropNameInTable="Vendor_Contact_NameColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Company_Name1" msprop:Generator_UserColumnName="Company_Name1" msprop:Generator_ColumnPropNameInRow="Company_Name1" msprop:Generator_ColumnVarNameInTable="columnCompany_Name1" msprop:Generator_ColumnPropNameInTable="Company_Name1Column" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="up_Report_InformationAsset_Inspections" msprop:Generator_UserTableName="up_Report_InformationAsset_Inspections" msprop:Generator_RowDeletedName="up_Report_InformationAsset_InspectionsRowDeleted" msprop:Generator_TableClassName="up_Report_InformationAsset_InspectionsDataTable" msprop:Generator_RowChangedName="up_Report_InformationAsset_InspectionsRowChanged" msprop:Generator_RowClassName="up_Report_InformationAsset_InspectionsRow" msprop:Generator_RowChangingName="up_Report_InformationAsset_InspectionsRowChanging" msprop:Generator_RowEvArgName="up_Report_InformationAsset_InspectionsRowChangeEvent" msprop:Generator_RowEvHandlerName="up_Report_InformationAsset_InspectionsRowChangeEventHandler" msprop:Generator_TablePropName="up_Report_InformationAsset_Inspections" msprop:Generator_TableVarName="tableup_Report_InformationAsset_Inspections" msprop:Generator_RowDeletingName="up_Report_InformationAsset_InspectionsRowDeleting">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="Vendor_InspVisit_XMissionStructure_PoleId" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_UserColumnName="Vendor_InspVisit_XMissionStructure_PoleId" msprop:Generator_ColumnPropNameInRow="Vendor_InspVisit_XMissionStructure_PoleId" msprop:Generator_ColumnVarNameInTable="columnVendor_InspVisit_XMissionStructure_PoleId" msprop:Generator_ColumnPropNameInTable="Vendor_InspVisit_XMissionStructure_PoleIdColumn" type="xs:int" />
              <xs:element name="Latitude" msprop:Generator_UserColumnName="Latitude" msprop:Generator_ColumnPropNameInRow="Latitude" msprop:Generator_ColumnVarNameInTable="columnLatitude" msprop:Generator_ColumnPropNameInTable="LatitudeColumn" type="xs:double" />
              <xs:element name="Longitude" msprop:Generator_UserColumnName="Longitude" msprop:Generator_ColumnPropNameInRow="Longitude" msprop:Generator_ColumnVarNameInTable="columnLongitude" msprop:Generator_ColumnPropNameInTable="LongitudeColumn" type="xs:double" />
              <xs:element name="Year" msprop:Generator_UserColumnName="Year" msprop:Generator_ColumnPropNameInRow="Year" msprop:Generator_ColumnVarNameInTable="columnYear" msprop:Generator_ColumnPropNameInTable="YearColumn" type="xs:int" minOccurs="0" />
              <xs:element name="LVisit" msprop:Generator_UserColumnName="LVisit" msprop:Generator_ColumnPropNameInRow="LVisit" msprop:Generator_ColumnVarNameInTable="columnLVisit" msprop:Generator_ColumnPropNameInTable="LVisitColumn" type="xs:dateTime" />
              <xs:element name="Number" msprop:Generator_UserColumnName="Number" msprop:Generator_ColumnPropNameInRow="Number" msprop:Generator_ColumnVarNameInTable="columnNumber" msprop:Generator_ColumnPropNameInTable="NumberColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="AcquisitionDate" msprop:Generator_UserColumnName="AcquisitionDate" msprop:Generator_ColumnPropNameInRow="AcquisitionDate" msprop:Generator_ColumnVarNameInTable="columnAcquisitionDate" msprop:Generator_ColumnPropNameInTable="AcquisitionDateColumn" type="xs:dateTime" />
              <xs:element name="TreatmentFk" msprop:Generator_UserColumnName="TreatmentFk" msprop:Generator_ColumnPropNameInRow="TreatmentFk" msprop:Generator_ColumnVarNameInTable="columnTreatmentFk" msprop:Generator_ColumnPropNameInTable="TreatmentFkColumn" type="xs:int" minOccurs="0" />
              <xs:element name="ClassFK" msprop:Generator_UserColumnName="ClassFK" msprop:Generator_ColumnPropNameInRow="ClassFK" msprop:Generator_ColumnVarNameInTable="columnClassFK" msprop:Generator_ColumnPropNameInTable="ClassFKColumn" type="xs:int" minOccurs="0" />
              <xs:element name="SpecieFk" msprop:Generator_UserColumnName="SpecieFk" msprop:Generator_ColumnPropNameInRow="SpecieFk" msprop:Generator_ColumnVarNameInTable="columnSpecieFk" msprop:Generator_ColumnPropNameInTable="SpecieFkColumn" type="xs:int" minOccurs="0" />
              <xs:element name="TopTypeFk" msprop:Generator_UserColumnName="TopTypeFk" msprop:Generator_ColumnPropNameInRow="TopTypeFk" msprop:Generator_ColumnVarNameInTable="columnTopTypeFk" msprop:Generator_ColumnPropNameInTable="TopTypeFkColumn" type="xs:int" minOccurs="0" />
              <xs:element name="Length" msprop:Generator_UserColumnName="Length" msprop:Generator_ColumnPropNameInRow="Length" msprop:Generator_ColumnVarNameInTable="columnLength" msprop:Generator_ColumnPropNameInTable="LengthColumn" type="xs:int" minOccurs="0" />
              <xs:element name="InspectorFk" msprop:Generator_UserColumnName="InspectorFk" msprop:Generator_ColumnPropNameInRow="InspectorFk" msprop:Generator_ColumnVarNameInTable="columnInspectorFk" msprop:Generator_ColumnPropNameInTable="InspectorFkColumn" type="xs:int" minOccurs="0" />
              <xs:element name="CompanyFk" msprop:Generator_UserColumnName="CompanyFk" msprop:Generator_ColumnPropNameInRow="CompanyFk" msprop:Generator_ColumnVarNameInTable="columnCompanyFk" msprop:Generator_ColumnPropNameInTable="CompanyFkColumn" type="xs:int" minOccurs="0" />
              <xs:element name="MapFk" msprop:Generator_UserColumnName="MapFk" msprop:Generator_ColumnPropNameInRow="MapFk" msprop:Generator_ColumnVarNameInTable="columnMapFk" msprop:Generator_ColumnPropNameInTable="MapFkColumn" type="xs:int" minOccurs="0" />
              <xs:element name="Vendor_InspVisit_XMissionStructureFk" msprop:Generator_UserColumnName="Vendor_InspVisit_XMissionStructureFk" msprop:Generator_ColumnPropNameInRow="Vendor_InspVisit_XMissionStructureFk" msprop:Generator_ColumnVarNameInTable="columnVendor_InspVisit_XMissionStructureFk" msprop:Generator_ColumnPropNameInTable="Vendor_InspVisit_XMissionStructureFkColumn" type="xs:int" minOccurs="0" />
              <xs:element name="Vendor_ProjectFK" msprop:Generator_UserColumnName="Vendor_ProjectFK" msprop:Generator_ColumnPropNameInRow="Vendor_ProjectFK" msprop:Generator_ColumnVarNameInTable="columnVendor_ProjectFK" msprop:Generator_ColumnPropNameInTable="Vendor_ProjectFKColumn" type="xs:int" minOccurs="0" />
              <xs:element name="Vendor_ContactFK" msprop:Generator_UserColumnName="Vendor_ContactFK" msprop:Generator_ColumnPropNameInRow="Vendor_ContactFK" msprop:Generator_ColumnVarNameInTable="columnVendor_ContactFK" msprop:Generator_ColumnPropNameInTable="Vendor_ContactFKColumn" type="xs:int" minOccurs="0" />
              <xs:element name="SectionFk" msprop:Generator_UserColumnName="SectionFk" msprop:Generator_ColumnPropNameInRow="SectionFk" msprop:Generator_ColumnVarNameInTable="columnSectionFk" msprop:Generator_ColumnPropNameInTable="SectionFkColumn" type="xs:int" minOccurs="0" />
              <xs:element name="Utility_Asset_XMissionStructures_PoleFk" msprop:Generator_UserColumnName="Utility_Asset_XMissionStructures_PoleFk" msprop:Generator_ColumnPropNameInRow="Utility_Asset_XMissionStructures_PoleFk" msprop:Generator_ColumnVarNameInTable="columnUtility_Asset_XMissionStructures_PoleFk" msprop:Generator_ColumnPropNameInTable="Utility_Asset_XMissionStructures_PoleFkColumn" type="xs:int" minOccurs="0" />
              <xs:element name="Treatment_Name" msprop:Generator_UserColumnName="Treatment_Name" msprop:Generator_ColumnPropNameInRow="Treatment_Name" msprop:Generator_ColumnVarNameInTable="columnTreatment_Name" msprop:Generator_ColumnPropNameInTable="Treatment_NameColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="TopType_Name" msprop:Generator_UserColumnName="TopType_Name" msprop:Generator_ColumnPropNameInRow="TopType_Name" msprop:Generator_ColumnVarNameInTable="columnTopType_Name" msprop:Generator_ColumnPropNameInTable="TopType_NameColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Specie_Name" msprop:Generator_UserColumnName="Specie_Name" msprop:Generator_ColumnPropNameInRow="Specie_Name" msprop:Generator_ColumnVarNameInTable="columnSpecie_Name" msprop:Generator_ColumnPropNameInTable="Specie_NameColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Class_Name" msprop:Generator_UserColumnName="Class_Name" msprop:Generator_ColumnPropNameInRow="Class_Name" msprop:Generator_ColumnVarNameInTable="columnClass_Name" msprop:Generator_ColumnPropNameInTable="Class_NameColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Vendor_InspVisit_XmissionStructures_ResultId" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_UserColumnName="Vendor_InspVisit_XmissionStructures_ResultId" msprop:Generator_ColumnPropNameInRow="Vendor_InspVisit_XmissionStructures_ResultId" msprop:Generator_ColumnVarNameInTable="columnVendor_InspVisit_XmissionStructures_ResultId" msprop:Generator_ColumnPropNameInTable="Vendor_InspVisit_XmissionStructures_ResultIdColumn" type="xs:int" />
              <xs:element name="Vendor_InspVisit_XMissionStructure_PoleFk" msprop:Generator_UserColumnName="Vendor_InspVisit_XMissionStructure_PoleFk" msprop:Generator_ColumnPropNameInRow="Vendor_InspVisit_XMissionStructure_PoleFk" msprop:Generator_ColumnVarNameInTable="columnVendor_InspVisit_XMissionStructure_PoleFk" msprop:Generator_ColumnPropNameInTable="Vendor_InspVisit_XMissionStructure_PoleFkColumn" type="xs:int" />
              <xs:element name="Vendor_InspVisit_XmissionStructures_Inspection_TypeFk" msprop:Generator_UserColumnName="Vendor_InspVisit_XmissionStructures_Inspection_TypeFk" msprop:Generator_ColumnPropNameInRow="Vendor_InspVisit_XmissionStructures_Inspection_TypeFk" msprop:Generator_ColumnVarNameInTable="columnVendor_InspVisit_XmissionStructures_Inspection_TypeFk" msprop:Generator_ColumnPropNameInTable="Vendor_InspVisit_XmissionStructures_Inspection_TypeFkColumn" type="xs:int" />
              <xs:element name="Vendor_InspVisit_XmissionStructures_ResultTypeFk" msprop:Generator_UserColumnName="Vendor_InspVisit_XmissionStructures_ResultTypeFk" msprop:Generator_ColumnPropNameInRow="Vendor_InspVisit_XmissionStructures_ResultTypeFk" msprop:Generator_ColumnVarNameInTable="columnVendor_InspVisit_XmissionStructures_ResultTypeFk" msprop:Generator_ColumnPropNameInTable="Vendor_InspVisit_XmissionStructures_ResultTypeFkColumn" type="xs:int" />
              <xs:element name="LastInspection" msprop:Generator_UserColumnName="LastInspection" msprop:Generator_ColumnPropNameInRow="LastInspection" msprop:Generator_ColumnVarNameInTable="columnLastInspection" msprop:Generator_ColumnPropNameInTable="LastInspectionColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Comments" msprop:Generator_UserColumnName="Comments" msprop:Generator_ColumnPropNameInRow="Comments" msprop:Generator_ColumnVarNameInTable="columnComments" msprop:Generator_ColumnPropNameInTable="CommentsColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="1073741823" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="bElectrical" msprop:Generator_UserColumnName="bElectrical" msprop:Generator_ColumnPropNameInRow="bElectrical" msprop:Generator_ColumnVarNameInTable="columnbElectrical" msprop:Generator_ColumnPropNameInTable="bElectricalColumn" type="xs:boolean" minOccurs="0" />
              <xs:element name="Type_Name" msprop:Generator_UserColumnName="Type_Name" msprop:Generator_ColumnPropNameInRow="Type_Name" msprop:Generator_ColumnVarNameInTable="columnType_Name" msprop:Generator_ColumnPropNameInTable="Type_NameColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Result_Name" msprop:Generator_UserColumnName="Result_Name" msprop:Generator_ColumnPropNameInRow="Result_Name" msprop:Generator_ColumnVarNameInTable="columnResult_Name" msprop:Generator_ColumnPropNameInTable="Result_NameColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Utility_Asset_XMissionStructureFK" msprop:Generator_UserColumnName="Utility_Asset_XMissionStructureFK" msprop:Generator_ColumnPropNameInRow="Utility_Asset_XMissionStructureFK" msprop:Generator_ColumnVarNameInTable="columnUtility_Asset_XMissionStructureFK" msprop:Generator_ColumnPropNameInTable="Utility_Asset_XMissionStructureFKColumn" type="xs:int" minOccurs="0" />
              <xs:element name="Vendor_InspVisit_XmissionStructures_NoteFk" msprop:Generator_UserColumnName="Vendor_InspVisit_XmissionStructures_NoteFk" msprop:Generator_ColumnPropNameInRow="Vendor_InspVisit_XmissionStructures_NoteFk" msprop:Generator_ColumnVarNameInTable="columnVendor_InspVisit_XmissionStructures_NoteFk" msprop:Generator_ColumnPropNameInTable="Vendor_InspVisit_XmissionStructures_NoteFkColumn" type="xs:int" minOccurs="0" />
              <xs:element name="Inspector_Name" msprop:Generator_UserColumnName="Inspector_Name" msprop:Generator_ColumnPropNameInRow="Inspector_Name" msprop:Generator_ColumnVarNameInTable="columnInspector_Name" msprop:Generator_ColumnPropNameInTable="Inspector_NameColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Company_Name" msprop:Generator_UserColumnName="Company_Name" msprop:Generator_ColumnPropNameInRow="Company_Name" msprop:Generator_ColumnVarNameInTable="columnCompany_Name" msprop:Generator_ColumnPropNameInTable="Company_NameColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Map_Name" msprop:Generator_UserColumnName="Map_Name" msprop:Generator_ColumnPropNameInRow="Map_Name" msprop:Generator_ColumnVarNameInTable="columnMap_Name" msprop:Generator_ColumnPropNameInTable="Map_NameColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Note_Name" msprop:Generator_UserColumnName="Note_Name" msprop:Generator_ColumnPropNameInRow="Note_Name" msprop:Generator_ColumnVarNameInTable="columnNote_Name" msprop:Generator_ColumnPropNameInTable="Note_NameColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:choice>
    </xs:complexType>
    <xs:unique name="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:up_Report_InformationAsset" />
      <xs:field xpath="mstns:Utility_Asset_XMissionStructureId" />
    </xs:unique>
  </xs:element>
  <xs:annotation>
    <xs:appinfo>
      <msdata:Relationship name="up_Report_InformationAsset_up_Report_InformationAsset_Gps" msdata:parent="up_Report_InformationAsset" msdata:child="up_Report_InformationAsset_Gps" msdata:parentkey="Utility_Asset_XMissionStructureId" msdata:childkey="Utility_Asset_XMissionStructureFK" msprop:Generator_UserRelationName="up_Report_InformationAsset_up_Report_InformationAsset_Gps" msprop:Generator_RelationVarName="relationup_Report_InformationAsset_up_Report_InformationAsset_Gps" msprop:Generator_UserChildTable="up_Report_InformationAsset_Gps" msprop:Generator_UserParentTable="up_Report_InformationAsset" msprop:Generator_ParentPropName="up_Report_InformationAssetRow" msprop:Generator_ChildPropName="Getup_Report_InformationAsset_GpsRows" />
      <msdata:Relationship name="up_Report_InformationAsset_up_Report_InformationAsset_Inspections" msdata:parent="up_Report_InformationAsset" msdata:child="up_Report_InformationAsset_Inspections" msdata:parentkey="Utility_Asset_XMissionStructureId" msdata:childkey="Utility_Asset_XMissionStructureFK" msprop:Generator_UserRelationName="up_Report_InformationAsset_up_Report_InformationAsset_Inspections" msprop:Generator_RelationVarName="relationup_Report_InformationAsset_up_Report_InformationAsset_Inspections" msprop:Generator_UserChildTable="up_Report_InformationAsset_Inspections" msprop:Generator_UserParentTable="up_Report_InformationAsset" msprop:Generator_ParentPropName="up_Report_InformationAssetRow" msprop:Generator_ChildPropName="Getup_Report_InformationAsset_InspectionsRows" />
    </xs:appinfo>
  </xs:annotation>
</xs:schema>